Datasources APIs

Data Source APIs for managing data sources and data models

API Methods

★ Includes Example(s)
◉ Can be used by Non-admin accounts

addHierarchyOverlayToModel

Set hierarchy overlay properties

2020.26

addHierarchySecurityToModel

Applies data security to model attribute hierarchies

2020.0

★

addMeasureOverlayToModel

Set measure overlay properties

2020.27

addMeasureSecurityToModel

Applies data security to model measures

2020.0

★

addMembersSecurityToModel

Applies data security to hierarchy members

2020.0

★

addRolesToDataBase

Add Roles to a Data Source Database

2018.5

★

addRolesToItemAndBubbleUp

Add roles to a data source item with bubble up.

2020.0

addRolesToItemAndPropagate

Add roles to a data source item with propagate down.

2020.0

addRolesToModel

Add Roles to a Materialized Model

2018.5

★

addRolesToServer

Add Roles to a Data Source Server

2018.5

★

changeDataSource

Change an Item's Data Source

2018.5

★

createDataServer

Create a new Data Source

2018.5

★

createDataServers

Create Multiple Data Sources from a List

2018.5

deleteDataBase

Delete an Existing Database

2018.5

★

deleteDataSource

Delete a Data Source

2018.5

★

deleteHierarchyOverlayFromModel

Removes hierarchy overlay properties

2020.26

deleteHierarchySecurityFromModel

Remove data security from model attribute hierarchies

2020.26

deleteMaterializedModel

Delete a Materialized Model

2018.5

★

deleteMeasureOverlayFromModel

Removes measure overlay properties

2020.27

deleteMeasureSecurityFromModel

Remove data security from model measures

2020.26

deleteMembersSecurityFromModel

Removes data security from hierarchy members

2020.26

deleteRolesFromDatabase

Delete Roles from a Data Source Database

2018.5

deleteRolesFromModel

Delete Roles from a Materialized Model

2018.5

deleteRolesFromServer

Delete Roles from a Data Source Server

2018.5

executeMasterFlow

Executes a Master Flow

2020.20

★

exportModel

Export a PIE file

2018.5

findDatabaseByName

Find a Data Source Database

2018.5

★

findModelByName

Find a Materialized model

2018.5

★

findServerByName

Find a Data Source Server

2018.5

★

getAllConnectionStrings

Get all Data Connections

2018.5

getDataModelStructure

Extract the structure of a data model

2020.0

getDataSourcesByTenant

Get all Datasources for a Tenant.

2018.5.2

getDataSourcesByUserId

Get an Tenant's Data Sources

2020.0

getDatasourceUsedTables

Get data source used tables.

2020.23

getItemConnectionString

Get an Item's Data Source Details

2018.5

getMasterFlowProgressUpdate

Get Master Flow Execution Progress

2020.20

★

getMasterFlowVariables

Get all variables in a Master Flow

2020.20

getRolesByDataBase

Get Data Source Database Roles

2018.5

getRolesByModel

Get Materialized Model Roles

2018.5

getRolesByServer

Get Data Source Server Roles

2018.5

★

getServerDataById

Get a Server's Data Details

2020.0

getSourceByNodeId

Get a specific Data Source by Data Flow Node ID

2020.20

getTargetByNodeId

Get a specific Data Target by Data Flow Node ID

2020.20

importModel

Import a Data Model

2018.5

★

recognizeDataBase

Recognize a Database

2018.5

★

recognizeModel

Recognize an existing Data Model

2020.0

updateDataFlowNodeSchemas

Update data source used schemas.

2020.23

updateModelName

Update model name.

2020.23

updateSourceNodeConnection

Update the Connection for a Data Source

2020.20

★

updateTargetNodeConnection

Update the Connection for a Data Target

2020.20

★

updateVariableConnection

Update the Connection for a Variable

2020.20

★

updateVariableValue

Sets the values of a list of variables

2020.20

validateMasterFlow

Validates a Master Flow

2020.20

★